from openpyxl import load_workbook, Workbook
from QuickTools.tools_pmc import (today_str1)

lj_BOM = "//192.168.70.101/19计划管理部/01.计划/1，数据处理工具/file/" + today_str1 + "/source_file_Ⅱ/BOM.xlsx"
wb= load_workbook(lj_BOM)
ws = wb["Sheet1"]

wb1 = Workbook()
ws1 = wb["Sheet1"]

def guige (sn):
    for i in range(2,in)




a=2
for i in range(2,ws.max_row+1):
    if ws.cell(i,3).value != ws1.cell(a,1).value:
        ws1.cell(a, 1).value = ws.cell(i,3).value

